package com.glsc.ngateway.common.base.repo.oracle.ecology;

import com.glsc.ngateway.common.base.domain.oracle.ecology.OaUserEmployInfo;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import java.util.List;

@Deprecated
@Repository
public interface OaUserRepository extends JpaRepository<OaUserEmployInfo, Integer>, JpaSpecificationExecutor<OaUserEmployInfo> {


    @Query(value = "select * from v_am_oa_hr_resource where OA_STATUS in (:statusList)", nativeQuery = true)
    List<OaUserEmployInfo> findAllByStatusList(List<String> statusList);
}
